﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_JZLGBL')
            and   type = 'U')
   drop table GXBZ_EMR_JZLGBL
go

/*==============================================================*/
/* Table: GXBZ_EMR_JZLGBL                                       */
/*==============================================================*/
create table GXBZ_EMR_JZLGBL (
   BLLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   MJZH                 varchar(32)          null,
   DZSQDBH              varchar(20)          null,
   KSMC                 varchar(64)          null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   JLRQSJ               datetime             null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   YSGH                 varchar(64)          null,
   YSXM                 varchar(30)          null,
   GMSBZ                varchar(1)           null,
   GMS                  char(1024)           null,
   ZS                   varchar(1024)        null,
   XBS                  varchar(1024)        null,
   JWS                  varchar(1024)        null,
   TGJC                 varchar(1024)        null,
   FZJCJG               varchar(1024)        null,
   CZBZDM               varchar(1)           null,
   SZGCJG               varchar(1024)        null,
   XYZDMC               varchar(100)         null,
   XYZDDM               varchar(10)          null,
   ZYBMMC               varchar(100)         null,
   ZYBMDM               varchar(10)          null,
   ZYZHMC               varchar(100)         null,
   ZYZHDM               varchar(10)          null,
   BZYJ                 varchar(100)         null,
   ZZZF                 varchar(100)         null,
   YZXMLXDM             varchar(2)           null,
   YZJHKSSJ             datetime             null,
   YZJHJSSJ             datetime             null,
   YZNR                 varchar(1024)        null,
   YZZXSJ               datetime             null,
   ZXRGH                varchar(64)          null,
   ZXRXM                varchar(30)          null,
   ZXKSMC               varchar(32)          null,
   YZKLSJ               datetime             null,
   YZKLRGH              varchar(64)          null,
   YZKLRXM              varchar(30)          null,
   YZKLKSMC             varchar(64)          null,
   SHSJ                 datetime             null,
   SHRGH                varchar(30)          null,
   YZZZSJ               datetime             null,
   TZYZZGH              varchar(64)          null,
   TZYZZXM              varchar(30)          null,
   BZ                   varchar(100)         null,
   YZZXZT               varchar(50)          null,
   SSCZBM               varchar(50)          null,
   SSCZMC               varchar(64)          null,
   SSCZBWMC             varchar(50)          null,
   JRWMC                varchar(100)         null,
   CZFFMS               varchar(1024)        null,
   CZCS                 decimal(3)           null,
   QJKSRQSJ             datetime             null,
   QJJSRQSJ             datetime             null,
   JZQJJL               varchar(1024)        null,
   CJQJRYMD             varchar(200)         null,
   ZYJSZWLBDM           varchar(30)          null,
   SRGCSRQSJ            datetime             null,
   JZLGBCJL             varchar(1024)        null,
   HZQXDM               varchar(1)           null,
   ZYSX                 varchar(1024)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_JZLGBL primary key (BLLSH, XGBZ)
)
go
